﻿CREATE TABLE [dbo].[Artikel] (
    [ArtikelKey]        INT            IDENTITY (1, 1) NOT NULL,
    [ArtikelTS]         NVARCHAR (25)  COLLATE Latin1_General_CI_AS NULL,
    [Änderung]          DATETIME       NULL,
    [ArtikelBez]        NVARCHAR (30)  COLLATE Latin1_General_CI_AS NULL,
    [HauptgruppenKey]   INT            NULL,
    [ProduktgruppenKey] INT            NULL,
    [Angebotstext]      NVARCHAR (255) COLLATE Latin1_General_CI_AS NULL,
    [Autotext]          NVARCHAR (25)  COLLATE Latin1_General_CI_AS NULL,
    CONSTRAINT [PK_Artikel] PRIMARY KEY CLUSTERED ([ArtikelKey] ASC)
);

